{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Start","Feed cost & analysis","Blend Calculator","Your notes","Hidden sheet"],"not_rendered":{"charts":0,"images":3,"macros":0,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,"AHDB Beef & Lamb Blend Calculator   (Version 2012:02)"]
[null,"A simple calculator to enable users to calculate the cost and,"]
[null,"energy and protein density of home blends"]
[]
[null,"To use this tool:"]
[null,1,null,"Data can only be entered in the white cells"]
[null,2,null,"Enter your own feed prices on the 'Feed cost & analysis' work sheet"]
[null,3,null,"Then go the 'Blend Calculator' sheet and select the feeds available "]
[null,4,null,"Nutrient costs are provided for each feed selected to help choose "]
[null,null,null,"which feeds offer best value for money"]
[null,5,null,"Enter the % inclusion of each feed - ensuring they add up to 100%"]
[null,6,null,"Look at the composition and price of the blend"]
[null,7,null,"Try different formulations as appropriate"]
[]
[null,"The advice of a beef cattle nutritionist should be sought if the user is unsure about the type of blend required"]
[]
[null,"Disclaimer"]
[null,"Reference herein to trade names and proprietary products and services without stating that they are protected does not imply that they may be regarded as unprotected"]
[null,"and thus free for general use.  No endorsement of named products is intended nor any criticism implied of alternative but unamed products."]
[]
[null,"The results obtained depend on the data entered by the user. It is the sole responsibility of the user to ensure that appropriate and accurate data are input about the feeds concerned."]
[]
[null,"AHDB Beef & Lamb is a division of the Agriculture and Horticulture Development Board (AHDB). "]
[null,"This program was produced by AHDB Beef & Lamb using reasonable care. To the greatest extent permissible by law, AHDB (including AHDB Beef & Lamb) and the authors of the software accept no liability"]
[null," for any loss, damage or injury directly or indirectly resulting from use of this program, whether caused by negligence or otherwise."]

{"sheet":"Feed cost & analysis","index":1,"n_rows":78,"n_cols":12,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,6,0,10]]}
[null,"Feed Cost","Enter your own prices below",null,null,null,"Nutrient composition expressed on a dry matter basis"]
["ID","Feed","Cost £/tonne FW","Cost £/tonne DM","DM %","ME (MJ/kg DM)","CP %","Oil %","NDF %","Starch %","Sugar %","Feeding notes  (also refer to EBLEX Mini Feeds Directory)"]
[1,"Barley                                                                                              ",150,{"$f":"C3/(E3/100)","v":174.41860465116278},86,13.1,12.1,2.8,21,57,2.5,"May cause acidosis if fed at high levels. Roll or grind as coarsely as possible to ensure all grains are just slightly damaged when fed to cattle or ewes fed high quality forage.  Cereal grains can be fed whole to sheep."]
[2,"Barley (Caustic Treated)",140,{"$f":"C4/(E4/100)","v":175},80,13,12.1,2.5,22.1,55,2.5,"High in sodium, this product needs a low salt mineral.  Sodium hydroxide is a hazardous chemical and should be handled with care, adhering to safety instructions of supplier.  Storage of moist grains will reduce the Vitamin E level."]
[3,"Barley (Crimped)",135,192.85714285714286,70,13.2,12.3,2.5,23.1,57,2.5,"May cause acidosis if fed at high levels. Crimp as coarsely as possible to ensure all grains are just slightly damaged."]
[4,"Barley (Propcorn treated)",145,176.82926829268294,82,13.2,12.3,2.5,23.1,57,2.5,"May cause acidosis if fed at high levels. Crimp as coarsely as possible to ensure all grains are just slightly damaged."]
[5,"Barley Distillers Dark Grain                                                                        ",170,191.01123595505618,89,12.2,26.5,8.5,42,2.6,3.7,"Many contain high levels of copper (50ppm) therefore can be dangerous to sheep.  The oil being cereal derived is unsaturated."]
[6,"Beans                                                                                               ",165,194.11764705882354,85,13.3,30,1.7,16.7,40,5.5,"Contain tannins and high levels in diets may reduce protein digestibility. Can be bitter if included at levels over 25% for calves but suitable at up to 50 % for older cattle in the concentrate mix."]
[7,"Biscuit Meal (10% Oil)",175,194.44444444444443,90,15,11,11,12,45,10,"High in energy, low in fibre. variable composition depending on source."]
[8,"Brewers Grains",33,126.92307692307692,26,11.5,24.5,7.7,61.8,5.5,1.5,"Brewers grains possess few limiting factors and can be fed up to 45% of total daily DM intake for cattle. Copper levels in distillery products can be dangerous for sheep. Can make dung loose."]
[9,"Citrus Pulp Feed                                                                                    ",35,38.888888888888886,90,12.2,6.5,2.6,37,0.2,25.5,"Product should not be added or removed quickly from a ration as it may cause refusal."]
[10,"Coconut Meal (Expellers)                                                                            ",190,211.11111111111111,90,13,22,8,45.5,2,10.3,"High in oil so additional vitamin E may be requied in the diet. Can be delivered with large lumps present so avoid use in auger mixing systems."]
[11,"Compound Feed 12% Protein",175,201.14942528735634,87,12.5,13.8,5.5,30,33,8,"Compound feeds must be fed alongside long roughage. Introduce gradually and usually do not exceed 65% of total dry matter intake unless on an ad lib system. If feeding ad lib ensure cattle never run out or they will gorge when re-fed and suffer severe acidosis."]
[12,"Compound Feed 14% Protein",185,212.64367816091954,87,12.5,16.100000000000001,5.5,30,33,8,"Compound feeds must be fed alongside long roughage. Introduce gradually and usually do not exceed 65% of total dry matter intake unless on an ad lib system. If feeding ad lib ensure cattle never run out or they will gorge when re-fed and suffer severe acidosis."]
[13,"Compound Feed 16% Protein",195,224.13793103448276,87,12.5,18.399999999999999,5.5,30,33,8,"Compound feeds must be fed alongside long roughage. Introduce gradually and usually do not exceed 65% of total dry matter intake unless on an ad lib system. If feeding ad lib ensure cattle never run out or they will gorge when re-fed and suffer severe acidosis."]
[14,"Compound Feed 18% Protein",200,229.88505747126436,87,12.5,20.7,5.5,30,33,8,"Compound feeds must be fed alongside long roughage. Introduce gradually and usually do not exceed 65% of total dry matter intake unless on an ad lib system. If feeding ad lib ensure cattle never run out or they will gorge when re-fed and suffer severe acidosis."]
[15,"Corn Steep Liquor                                                                                   ",75,166.66666666666666,45,13,40,1,0,5,24,"Physical consistency may vary and gelling may produce physical problems. pH is low (4-5).  Potassium and salt levels are high which can cause scouring at higher levels."]
[16,"Cotton Seed Meal (Extraction)                                                                       ",265,286.79653679653677,92.4,11.1,37.5,6.7,38.5,3,6,"Aflatoxins can be high and guarantees should be sought from suppliers.  Gossypol present can produce digestive and palatability upsets, reducing performance at high levels in young animals by affecting protein digestibility.  Can be delivered with large large lumps present so avoid use in auger mixing systems."]
[17,"Draff                                                                                               ",25,108.69565217391303,23,11.6,25,6,57.5,3.2,1.8,"High copper levels (60mg/kg DM) can make this dangerous to sheep, but low in other minerals except phosphorus."]
[18,"Fat (Calcium soap Protected)                                                                                     ",600,606.06060606060612,99,29,0,86,0,0,0,"Good energy source but very expensive and usually not economical for beef diets."]
[19,"Fodder Beet                                                                                         ",24,133.33333333333334,18,12,6,4,13.6,2,64.7,"Fodder beet should be well cleaned, preferably at harvesting, but certainly before feeding.  Fodder beet tops can also be fed and are of a lower of dry matter (12%) and energy (10MJ/kg DM),but higher in protein (16%) content.  Tops should be wilted to avoid metabolic and digestive upsets.  Can be grazed in situ."]
[20,"Groundnut Meal/Cake                                                                                 ",260,288.88888888888886,90,13.2,53,7,16,7,7,"Aflatoxin contamination is common but all consignments are tested at port. Ensure each load has a test certificate. Can be delivered with large lumps present so avoid use in auger mixing systems."]
[21,"Limestone Flour",80,84.21052631578948,95,0,0,0,0,0,0,"A cost effective acid neutraliser in the rumen."]
[22,"Linseed Meal (Expellers)",250,277.77777777777777,90,12.8,36,8.1,18.899999999999999,4.5,4.5," High levels can have a laxative effect."]
[23,"Linseed Whole                                                                                       ",280,311.11111111111109,90,19,26,31,10,10,3.5," High levels can have a laxative effect."]
[24,"Lupins",250,290.69767441860466,86,14.5,32,5.3,33.1,9,4,"Can be bitter and reduce feed intake if included at more than 15% of total DM in calf feeds, Good energy and protein source for cattle over 4 months and sheep at higher inclusion rates."]
[25,"Maize (Ground ear)",90,163.63636363636363,55,12.5,7.8,4.4000000000000004,25,55,5,"Dry matter and quality can vary due to stage of maturity at harvesting. Suggest samples are analysed if forming a significant part of the diet."]
[26,"Maize Distiller Grains",175,196.62921348314606,89,14,31.7,10.8,34.299999999999997,4.5,5.5,"Distillers products are low in starch and high in oil. The oil can reduce fibre digestion and reduce total feed intake so limit inclusion to 30% of the total diet dry matter.  High copper levels in distillery products can make them dangerous to sheep.  "]
[27,"Maize Germ Meal                                                              ",200,227.27272727272728,88,14.5,11,8.1999999999999993,36.5,23,7,"High oil maize germ can reduce fibre digestion if fed for long periods.  It can also cause scouring. Lower oil products have few limits to usage."]
[28,"Maize Gluten Feed                                                                                   ",165,187.5,88,12.9,22,5.2,38.6,22,3.5,"This starch can be highly degradable.  Protein levels can vary from source to source.  Needs a good source of supplementary minerals when used at maximum levels for ruminant diets (45% of total daily DMI)."]
[29,"Maize Grain (Crimped)",140,200,70,13.8,10,4.4000000000000004,11.7,68,2,"A very high feed value grain with lower risk of acidosis than other cereals."]
[30,"Maize Meal",165,191.86046511627907,86,13.8,10,4.4000000000000004,11.7,68,2,"A very high feed value grain with lower risk of acidosis than other cereals."]
[31,"Malt Culms",125,138.88888888888889,90,11.2,28,2.6,46,6,11,"Dried sprouts and roots of barley grains with low digestibility."]
[32,"Malt Pellets                                                                                        ",125,138.88888888888889,90,11.2,24.5,2.2000000000000002,51.2,16.100000000000001,0.4,"Less palatable than the barley they were derived from but usually a good physical pellet which can be useful in a mix."]
[33,"Malt Residual Pellets",125,138.88888888888889,90,11.2,24.5,2.2000000000000002,51.2,16.100000000000001,0.4,"Less palatable than the barley they were derived from but usually a good physical pellet which can be useful in a mix."]
[34,"Mineral/Vitamin Supplement",350,384.61538461538458,91,0,0,0,0,0,0,"A range of supplements is available, seek expert help for balancing the correct one with the feeds being used and the stock being fed."]
[35,"Molasses (Beet)                                                                                     ",155,206.66666666666666,75,12.2,7.5,0.4,0,0,66,"It has a high potassium and salt content which can lead to 'scouring' especially in younger animals.  High levels of sugar could lead to acidosis."]
[36,"Molasses (Cane)                                                                                     ",160,213.33333333333334,75,12.7,4,0.2,0,0,65,"It has a high potassium and salt content which can lead to 'scouring' especially in younger animals.  High levels of sugar could lead to acidosis."]
[37,"Molasses with Urea (24% Protein)",180,260.86956521739131,69,11.8,24,0.4,0,0,55,"This product contains a high level of urea and should be fed at 1 to 2 litres depending on size of animal. Not suitable for calves under 3 months old. \nCan be used as a dust suppressant with rolled cereal mixes."]
[38,"Molasses with Urea (30% Protein)",180,260.86956521739131,69,11.8,30,0.4,0,0,55,"This product contains a high level of urea and should be fed at 1 to 1.5 litres depending on size of animal. Not suitable for calves under 3 months old. \nCan be used as a dust suppressant with rolled cereal mixes."]
[39,"Molasses with Urea (44% Protein)",180,260.86956521739131,69,11.8,44,0.4,0,0,55,"This product contains a high level of urea and should be fed at 0.5 to 1 litre depending on size of animal. Not suitable for calves under 3 months old. \nCan be used as a dust suppressant with rolled cereal mixes."]
[40,"Oat Feed                                                                                            ",90,104.65116279069768,86,5.6,5.0999999999999996,2.5,70,7.5,2,"Low energy value and of generally low nutritive value."]
[41,"Oats                                                                                                ",120,139.53488372093022,86,12.2,11.2,4,37,42,1.1000000000000001,"Modern varieties can be as high in energy as barley and the combination of fibre and starch makes them the safest of all the cereals to feed at high levels."]
[42,"Palm Kernel Meal (Expeller)                                                                         ",130,144.44444444444443,90,11.6,17,7.6,69.3,4,1.7,"May contain high levels of aflaxtoxin and salmonella so seek supplier assurances.  "]
[43,"Parsnips                                                                                            ",20,133.33333333333334,15,13,8.5,1.5,47.5,3,8,"High in energy but low in protein.  Soil contamination can be a problem."]
[44,"Peas (Dried)                                                                                        ",185,211.42857142857142,87.5,13.5,25.7,2.4,15.9,43.5,6,"Very palatable to all stock."]
[45,"Pot Ale Syrup                                                                                       ",70,155.55555555555554,45,14.2,37,0.2,0.7,1.3,2.8,"High in copper and potassium which may cause scouring.  Can be highly viscous."]
[46,"Potatoes                                                                                            ",25,{"$f":"C48/(E48/100)","v":119.04761904761905},21,13.3,9.3000000000000007,0.2,7.6,62,8,"High in starch, so over feeding may encourage acidosis.  Rotten, green and dirty potatoes should be avoided, as they may contain alkaloids.  Chopping is recommended to reduce the risk of choking and always feed at ground level, not in raised troughs.  Sprouted potatoes are dangerous to livestock.  Avoid soil contamination."]
[47,"Protein Concentrate with minerals (33%)",280,318.18181818181819,88,12.1,33,3.2,36.5,5,9.5,"A mineralised protein concentrate which may contain urea. If urea present do not feed to cattle/sheep under 3 months old."]
[48,"Protein Concentrate with minerals (50%)",300,340.90909090909093,88,12.1,50,3.2,36.5,5,9.5,"A mineralised protein concentrate which may contain urea. If urea present do not feed to cattle/sheep under 3 months old."]
[49,"Rapeseed Meal                                                                                       ",175,194.44444444444443,90,12,38.5,5.3,29.4,5,9.5,"A good basic protein source for ruminants. Can make mixes bitter if used at over 20% inclusion."]
[50,"Rye                                                                                                 ",150,172.41379310344828,87,13.5,11.6,1.8,38,45,3,"Beware of contamination by the fungus ergot."]
[51,"Soya Bean Hulls",135,150,90,11.9,11.6,2.4,67.5,5,9,"Very palatable and used as a slightly lower grade sugar beet pulp replacer. Pelleted but with still quite a lot of dust in some loads."]
[52,"Soya Bean Meal (Brazilian)                                                                          ",280,311.11111111111109,90,13.4,50,3.1,11,4.5,10,"A very good protein source with the hulls (husk) left in the meal giving it a higher fibre and lower protein content than North American Soya."]
[53,"Soya Bean Meal (Hi-pro)                                                                             ",290,322.22222222222223,90,13.3,52,2.7,12.5,5,11,"A very good protein source with the hulls (husk) removed giving it a lower fibre and higher protein content than South American Soya."]
[54,"Sugar Beet  (Whole roots)",24,114.28571428571429,21,12.5,6.5,1,20,0.1,59.9,"Can be very hard in cold weather and cattle around 12 months old changing their teeth may struggle to acheive adequate intakes if grazed. If lifted and fed to housed cattle they may need chopping."]
[55,"Sugar Beet Pulp (Molassed)                                                                          ",160,177.77777777777777,90,12.5,12.1,0.4,32,20,23,"Contains highly digestible fibre which helps maintain  rumen function."]
[56,"Sugar Beet Pulp (Pressed)                                                                           ",48,240,20,12.1,9.5,0.2,52.3,0.4,4.5999999999999996,"Should be used within 5-7 days of leaving the factory to avoid the growth of harmful moulds.  If kept for more than 2-3 days, it should be ensiled and fully sealed.  Care must be taken to ensure that there is adequate coarse long fibre in the ration."]
[57,"Sunflower Meal (32% protein)",155,176.13636363636363,88,9.5,36,2.5,47,1,6,"A high fibre protein source with poor palatability so limit inclusion to 20% of concentrate feeds."]
[58,"Sunflower Meal (38% protein)",175,198.86363636363637,88,11.5,45,3,42,6,6.5,"A high fibre protein source with poor palatability so limit inclusion to 20% of concentrate feeds."]
[59,"Triticale",140,162.7906976744186,86,13.4,12,1.9,13.2,65,4,"May cause acidosis if fed at high levels. Roll or grind as coarsely as possible to ensure all grains are just slightly damaged when fed to cattle or ewes fed high quality forage. Cereal grains can be fed whole to sheep."]
[60,"Urea (Feed Grade)                                                                                   ",350,351.75879396984925,99.5,0,280,0,0,0,0,"Very high protein content so accurate mixing is essential and ensure all lumps  are broken up. Feed rate is very low due to the high protein content at 25g per head at 200 kg LW to 100 g at 600 kg LW, maximum. Must not be fed to cattle under 3 months old."]
[61,"Wet Distillers Grains eg. Vitagold",70,200,35,14.5,36,10,43,6,1,"Very palatable high energy feed usually only available in the north of the country. Composition will vary according to the grain used as the raw material."]
[62,"Wheat                                                                                               ",165,191.86046511627907,86,13.7,12.6,2.2999999999999998,12,67,4,"Contains high levels of gluten which, if finely ground, can result in a sticky dough reducing digestion.  The readily fermentable carbohydrate present can also cause acidosis when fed at high levels. Consider using limestone or sodium bicarbonate to neutralise acidity in rumen if fed at high levels."]
[63,"Wheat (Caustic Treated)",165,235.71428571428572,70,13.5,12.5,2,11,66,4,"High in sodium, this product needs a low salt mineral.  Sodium hydroxide is a hazardous chemical and should be handled with care, adhering to safety instructions of supplier.  Storage of moist grains will reduce the Vitamin E level. "]
[64,"Wheat (Crimped)",155,221.42857142857144,70,13.8,13,1.8,12,67,4,"Contains high levels of gluten which, if finely ground, can result in a sticky dough reducing digestion.  The readily fermentable carbohydrate present can also cause acidosis when fed at high levels. Consider using limestone or sodium bicarbonate to neutralise acidity of fed at high levels."]
[65,"Wheat Bran                                                                                          ",130,151.16279069767441,86,11,17.5,4,47,19.5,6.5,"No anti-nutritive factors, although the physical nature may limit inclusion rates."]
[66,"Wheat Moist Co-Product eg. Trafford Gold",70,{"$f":"C68/(E68/100)","v":140},50,13.4,21,5,21,17.5,6.5,"Good palatability, maximum inclusion rates of 50-60% of total daily DM intake are recommended for finishing cattle."]
[67,"Wheat Distillers Dark Grains",175,194.44444444444443,90,13.5,34,7,33.5,5,5,"May contain high copper levels (150 ppm) which could be particulalrly dangerous to sheep so check with supplier. New biofuel plants in the UK using stainless steel plant will not produce high copper material. Maximum inclusion rate of 40% recommended."]
[68,"Wheat Feed                                                                                          ",150,170.45454545454547,88,11.9,18.2,5.0999999999999996,10.5,27.5,6.5,"Can be unpalatable unless mixed in with other moist feeds."]
[69,"Whey Syrup                                                                                          ",65,138.29787234042553,47,13,22,0,0,0,12,"Low dry matter and high salt content.  Maximum recommended inclusion rate is 10%."]
[70,"Enter your own feed here if it is not listed",11,12.790697674418604,86,1,1]
[71,"Enter your own feed here if it is not listed",22,73.333333333333343,30,1,1]
[72,"Enter your own feed here if it is not listed",33,38.82352941176471,85,10,20]
[73,"Enter your own feed here if it is not listed",44,51.764705882352942,85,10,20]
[74,"Enter your own feed here if it is not listed",55,64.705882352941174,85,10,20]
[]
[null,"Note:  All feeds must be allocated a cost £/tonne FW"]

{"sheet":"Blend Calculator","index":2,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,5,4,9],[5,12,5,13],[10,14,10,15],[11,14,11,15]]}
[null,"AHDB Beef & Lamb Blend Calculator"]
[]
[null,"What feeds are potentially available?"]
[]
[null,"Inclusion rates must total 100%",null,{"$f":"D18","v":1},null,"Nutrient cost"]
[null,"Feeds",null,"% of blend (FW)",null,"DM\n£/tonne DM",null,"Unit cost of energy",null,"Unit cost of protein",null,null,"Blend Composition ",null,"DM basis","FW basis"]
[null,1,null,0.7,null,{"$f":"IF(VLOOKUP(B7,'Feed cost & analysis'!1:1048576,4,FALSE)=0,\"\",VLOOKUP(B7,'Feed cost & analysis'!1:1048576,4,FALSE))","v":174.41860465116278},{"$f":"VLOOKUP(B7,'Feed cost & analysis'!1:1048576,4,FALSE)","v":174.41860465116278},{"$f":"IF(VLOOKUP(B7,'Feed cost & analysis'!1:1048576,6,FALSE)=0,\"\",(F7/10)/((VLOOKUP(B7,'Feed cost & analysis'!1:1048576,6,FALSE))))","v":1.3314397301615479},{"$f":"(F7/10)/((VLOOKUP(B7,'Feed cost & analysis'!1:1048576,6,FALSE)))","v":1.3314397301615479},{"$f":"IF(VLOOKUP(B7,'Feed cost & analysis'!1:1048576,7,FALSE)=0,\"\",((F7/1000)/((VLOOKUP(B7,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100)","v":14.414760714972131},{"$f":"((F7/1000)/((VLOOKUP(B7,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100","v":14.414760714972131},null,"Dry matter %",null,{"$f":"'Hidden sheet'!G14","v":0.86599999999999999},{"$f":"'Hidden sheet'!G14","v":0.86599999999999999}]
[null,47,null,0.3,null,{"$f":"IF(VLOOKUP(B8,'Feed cost & analysis'!1:1048576,4,FALSE)=0,\"\",VLOOKUP(B8,'Feed cost & analysis'!1:1048576,4,FALSE))","v":318.18181818181819},{"$f":"VLOOKUP(B8,'Feed cost & analysis'!1:1048576,4,FALSE)","v":318.18181818181819},{"$f":"IF(VLOOKUP(B8,'Feed cost & analysis'!1:1048576,6,FALSE)=0,\"\",(F8/10)/((VLOOKUP(B8,'Feed cost & analysis'!1:1048576,6,FALSE))))","v":2.6296018031555226},{"$f":"(F8/10)/((VLOOKUP(B8,'Feed cost & analysis'!1:1048576,6,FALSE)))","v":2.6296018031555226},{"$f":"IF(VLOOKUP(B8,'Feed cost & analysis'!1:1048576,7,FALSE)=0,\"\",((F8/1000)/((VLOOKUP(B8,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100)","v":9.6418732782369148},{"$f":"((F8/1000)/((VLOOKUP(B8,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100","v":9.6418732782369148},null,"Crude protein  %",null,{"$f":"'Hidden sheet'!I14/1000","v":0.18471362586605078},{"$f":"'Hidden sheet'!I13/1000","v":0.15996199999999999}]
[null,41,null,0,null,{"$f":"IF(VLOOKUP(B9,'Feed cost & analysis'!1:1048576,4,FALSE)=0,\"\",VLOOKUP(B9,'Feed cost & analysis'!1:1048576,4,FALSE))","v":139.53488372093022},{"$f":"VLOOKUP(B9,'Feed cost & analysis'!1:1048576,4,FALSE)","v":139.53488372093022},{"$f":"IF(VLOOKUP(B9,'Feed cost & analysis'!1:1048576,6,FALSE)=0,\"\",(F9/10)/((VLOOKUP(B9,'Feed cost & analysis'!1:1048576,6,FALSE))))","v":1.1437285550895921},{"$f":"(F9/10)/((VLOOKUP(B9,'Feed cost & analysis'!1:1048576,6,FALSE)))","v":1.1437285550895921},{"$f":"IF(VLOOKUP(B9,'Feed cost & analysis'!1:1048576,7,FALSE)=0,\"\",((F9/1000)/((VLOOKUP(B9,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100)","v":12.458471760797343},{"$f":"((F9/1000)/((VLOOKUP(B9,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100","v":12.458471760797343},null,"Starch %",null,{"$f":"('Hidden sheet'!J14)/100","v":0.41147806004618936},{"$f":"'Hidden sheet'!J13/100","v":0.35633999999999999}]
[null,53,null,0,null,{"$f":"IF(VLOOKUP(B10,'Feed cost & analysis'!1:1048576,4,FALSE)=0,\"\",VLOOKUP(B10,'Feed cost & analysis'!1:1048576,4,FALSE))","v":322.22222222222223},{"$f":"VLOOKUP(B10,'Feed cost & analysis'!1:1048576,4,FALSE)","v":322.22222222222223},{"$f":"IF(VLOOKUP(B10,'Feed cost & analysis'!1:1048576,6,FALSE)=0,\"\",(F10/10)/((VLOOKUP(B10,'Feed cost & analysis'!1:1048576,6,FALSE))))","v":2.4227234753550539},{"$f":"(F10/10)/((VLOOKUP(B10,'Feed cost & analysis'!1:1048576,6,FALSE)))","v":2.4227234753550539},{"$f":"IF(VLOOKUP(B10,'Feed cost & analysis'!1:1048576,7,FALSE)=0,\"\",((F10/1000)/((VLOOKUP(B10,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100)","v":6.1965811965811968},{"$f":"((F10/1000)/((VLOOKUP(B10,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100","v":6.1965811965811968},null,"ME   MJ/kg DM",null,{"$f":"'Hidden sheet'!H14","v":12.795150115473442},{"$f":"'Hidden sheet'!H13","v":11.0806}]
[null,49,null,0,null,{"$f":"IF(VLOOKUP(B11,'Feed cost & analysis'!1:1048576,4,FALSE)=0,\"\",VLOOKUP(B11,'Feed cost & analysis'!1:1048576,4,FALSE))","v":194.44444444444443},{"$f":"VLOOKUP(B11,'Feed cost & analysis'!1:1048576,4,FALSE)","v":194.44444444444443},{"$f":"IF(VLOOKUP(B11,'Feed cost & analysis'!1:1048576,6,FALSE)=0,\"\",(F11/10)/((VLOOKUP(B11,'Feed cost & analysis'!1:1048576,6,FALSE))))","v":1.6203703703703702},{"$f":"(F11/10)/((VLOOKUP(B11,'Feed cost & analysis'!1:1048576,6,FALSE)))","v":1.6203703703703702},{"$f":"IF(VLOOKUP(B11,'Feed cost & analysis'!1:1048576,7,FALSE)=0,\"\",((F11/1000)/((VLOOKUP(B11,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100)","v":5.0505050505050502},{"$f":"((F11/1000)/((VLOOKUP(B11,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100","v":5.0505050505050502},null,"Ration cost  (tonne DM)",null,{"$f":"'Hidden sheet'!F14","v":217.54756871035937}]
[null,6,null,0,null,{"$f":"IF(VLOOKUP(B12,'Feed cost & analysis'!1:1048576,4,FALSE)=0,\"\",VLOOKUP(B12,'Feed cost & analysis'!1:1048576,4,FALSE))","v":194.11764705882354},{"$f":"VLOOKUP(B12,'Feed cost & analysis'!1:1048576,4,FALSE)","v":194.11764705882354},{"$f":"IF(VLOOKUP(B12,'Feed cost & analysis'!1:1048576,6,FALSE)=0,\"\",(F12/10)/((VLOOKUP(B12,'Feed cost & analysis'!1:1048576,6,FALSE))))","v":1.4595311808934102},{"$f":"(F12/10)/((VLOOKUP(B12,'Feed cost & analysis'!1:1048576,6,FALSE)))","v":1.4595311808934102},{"$f":"IF(VLOOKUP(B12,'Feed cost & analysis'!1:1048576,7,FALSE)=0,\"\",((F12/1000)/((VLOOKUP(B12,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100)","v":6.4705882352941186},{"$f":"((G12/1000)/((VLOOKUP(B12,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100","v":6.4705882352941186},null,"Ration cost  (tonne FW)",null,{"$f":"O11*O7","v":188.39619450317122}]
[null,45,null,0,null,{"$f":"IF(VLOOKUP(B13,'Feed cost & analysis'!1:1048576,4,FALSE)=0,\"\",VLOOKUP(B13,'Feed cost & analysis'!1:1048576,4,FALSE))","v":155.55555555555554},{"$f":"VLOOKUP(B13,'Feed cost & analysis'!1:1048576,4,FALSE)","v":155.55555555555554},{"$f":"IF(VLOOKUP(B13,'Feed cost & analysis'!1:1048576,6,FALSE)=0,\"\",(F13/10)/((VLOOKUP(B13,'Feed cost & analysis'!1:1048576,6,FALSE))))","v":1.0954616588419404},{"$f":"(F13/10)/((VLOOKUP(B13,'Feed cost & analysis'!1:1048576,6,FALSE)))","v":1.0954616588419404},{"$f":"IF(VLOOKUP(B13,'Feed cost & analysis'!1:1048576,7,FALSE)=0,\"\",((F13/1000)/((VLOOKUP(B13,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100)","v":4.2042042042042027},{"$f":"((F13/1000)/((VLOOKUP(B13,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100","v":4.2042042042042027}]
[null,60,null,0,null,{"$f":"IF(VLOOKUP(B14,'Feed cost & analysis'!1:1048576,4,FALSE)=0,\"\",VLOOKUP(B14,'Feed cost & analysis'!1:1048576,4,FALSE))","v":351.75879396984925},{"$f":"VLOOKUP(B14,'Feed cost & analysis'!1:1048576,4,FALSE)","v":351.75879396984925},{"$f":"IF(VLOOKUP(B14,'Feed cost & analysis'!1:1048576,6,FALSE)=0,\"\",(F14/10)/((VLOOKUP(B14,'Feed cost & analysis'!1:1048576,6,FALSE))))","v":""},{"$f":"(F14/10)/((VLOOKUP(B14,'Feed cost & analysis'!1:1048576,6,FALSE)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(VLOOKUP(B14,'Feed cost & analysis'!1:1048576,7,FALSE)=0,\"\",((F14/1000)/((VLOOKUP(B14,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100)","v":1.256281407035176},{"$f":"((F14/1000)/((VLOOKUP(B14,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100","v":1.256281407035176}]
[null,70,null,0,null,{"$f":"IF(VLOOKUP(B15,'Feed cost & analysis'!1:1048576,4,FALSE)=0,\"\",VLOOKUP(B15,'Feed cost & analysis'!1:1048576,4,FALSE))","v":12.790697674418604},{"$f":"VLOOKUP(B15,'Feed cost & analysis'!1:1048576,4,FALSE)","v":12.790697674418604},{"$f":"IF(VLOOKUP(B15,'Feed cost & analysis'!1:1048576,6,FALSE)=0,\"\",(F15/10)/((VLOOKUP(B15,'Feed cost & analysis'!1:1048576,6,FALSE))))","v":1.2790697674418605},{"$f":"(F15/10)/((VLOOKUP(B15,'Feed cost & analysis'!1:1048576,6,FALSE)))","v":1.2790697674418605},{"$f":"IF(VLOOKUP(B15,'Feed cost & analysis'!1:1048576,7,FALSE)=0,\"\",((F15/1000)/((VLOOKUP(B15,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100)","v":12.790697674418603},{"$f":"((F15/1000)/((VLOOKUP(B15,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100","v":12.790697674418603}]
[null,74,null,0,null,{"$f":"IF(VLOOKUP(B16,'Feed cost & analysis'!1:1048576,4,FALSE)=0,\"\",VLOOKUP(B16,'Feed cost & analysis'!1:1048576,4,FALSE))","v":64.705882352941174},{"$f":"VLOOKUP(B16,'Feed cost & analysis'!1:1048576,4,FALSE)","v":64.705882352941174},{"$f":"IF((VLOOKUP(B16,'Feed cost & analysis'!1:1048576,6,FALSE))=0,\"\",(F16/10)/((VLOOKUP(B16,'Feed cost & analysis'!1:1048576,6,FALSE))))","v":0.6470588235294118},{"$f":"(F16/10)/((VLOOKUP(B16,'Feed cost & analysis'!1:1048576,6,FALSE)))","v":0.6470588235294118},{"$f":"IF(VLOOKUP(B16,'Feed cost & analysis'!1:1048576,7,FALSE)=0,\"\",((F16/1000)/((VLOOKUP(B16,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100)","v":3.2352941176470584},{"$f":"((F16/1000)/((VLOOKUP(B16,'Feed cost & analysis'!1:1048576,7,FALSE))/10))*100","v":3.2352941176470584}]
[]
[null,"Blend results",null,{"$f":"SUM(D7,D8,D9,D10,D11,D12,D13,D14,D15,D16)","v":1},null,"Inclusion rates must total 100%"]

{"sheet":"Your notes","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Hidden sheet","index":4,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["DM","ME","CP","Starch","FW %","% cost","DM\ng/kg","ME\nMJ/kgDM","CP\ng/kgDM","Starch"]
[{"$f":"VLOOKUP('Blend Calculator'!B7,'Feed cost & analysis'!1:1048576,5,FALSE)","v":86},{"$f":"VLOOKUP('Blend Calculator'!B7,'Feed cost & analysis'!1:1048576,6,FALSE)","v":13.1},{"$f":"VLOOKUP('Blend Calculator'!B7,'Feed cost & analysis'!1:1048576,7,FALSE)","v":12.1},{"$f":"VLOOKUP('Blend Calculator'!B7,'Feed cost & analysis'!1:1048576,10,FALSE)","v":57},{"$f":"'Blend Calculator'!D7","v":0.7},{"$f":"'Blend Calculator'!F7*'Blend Calculator'!D7","v":122.09302325581393},{"$f":"(1000*(E2)*(A2/100))","v":602},{"$f":"(G2/1000)*B2","v":7.8861999999999997},{"$f":"G2*(C2/100)","v":72.841999999999999},{"$f":"(G2/1000)*D2","v":34.314}]
[{"$f":"VLOOKUP('Blend Calculator'!B8,'Feed cost & analysis'!1:1048576,5,FALSE)","v":88},{"$f":"VLOOKUP('Blend Calculator'!B8,'Feed cost & analysis'!1:1048576,6,FALSE)","v":12.1},{"$f":"VLOOKUP('Blend Calculator'!B8,'Feed cost & analysis'!1:1048576,7,FALSE)","v":33},{"$f":"VLOOKUP('Blend Calculator'!B8,'Feed cost & analysis'!1:1048576,10,FALSE)","v":5},{"$f":"'Blend Calculator'!D8","v":0.3},{"$f":"'Blend Calculator'!F8*'Blend Calculator'!D8","v":95.454545454545453},{"$f":"(1000*(E3)*(A3/100))","v":264},{"$f":"(G3/1000)*B3","v":3.1943999999999999},{"$f":"G3*(C3/100)","v":87.12},{"$f":"(G3/1000)*D3","v":1.32}]
[{"$f":"VLOOKUP('Blend Calculator'!B9,'Feed cost & analysis'!1:1048576,5,FALSE)","v":86},{"$f":"VLOOKUP('Blend Calculator'!B9,'Feed cost & analysis'!1:1048576,6,FALSE)","v":12.2},{"$f":"VLOOKUP('Blend Calculator'!B9,'Feed cost & analysis'!1:1048576,7,FALSE)","v":11.2},{"$f":"VLOOKUP('Blend Calculator'!B9,'Feed cost & analysis'!1:1048576,10,FALSE)","v":42},{"$f":"'Blend Calculator'!D9","v":0},{"$f":"'Blend Calculator'!F9*'Blend Calculator'!D9","v":0},{"$f":"(1000*(E4)*(A4/100))","v":0},0,{"$f":"G4*(C4/100)","v":0},0]
[{"$f":"VLOOKUP('Blend Calculator'!B10,'Feed cost & analysis'!1:1048576,5,FALSE)","v":90},{"$f":"VLOOKUP('Blend Calculator'!B10,'Feed cost & analysis'!1:1048576,6,FALSE)","v":13.3},{"$f":"VLOOKUP('Blend Calculator'!B10,'Feed cost & analysis'!1:1048576,7,FALSE)","v":52},{"$f":"VLOOKUP('Blend Calculator'!B10,'Feed cost & analysis'!1:1048576,10,FALSE)","v":5},{"$f":"'Blend Calculator'!D10","v":0},{"$f":"'Blend Calculator'!F10*'Blend Calculator'!D10","v":0},0,0,{"$f":"G5*(C5/100)","v":0},0]
[{"$f":"VLOOKUP('Blend Calculator'!B11,'Feed cost & analysis'!1:1048576,5,FALSE)","v":90},{"$f":"VLOOKUP('Blend Calculator'!B11,'Feed cost & analysis'!1:1048576,6,FALSE)","v":12},{"$f":"VLOOKUP('Blend Calculator'!B11,'Feed cost & analysis'!1:1048576,7,FALSE)","v":38.5},{"$f":"VLOOKUP('Blend Calculator'!B11,'Feed cost & analysis'!1:1048576,10,FALSE)","v":5},{"$f":"'Blend Calculator'!D11","v":0},{"$f":"'Blend Calculator'!F11*'Blend Calculator'!D11","v":0},{"$f":"(1000*(E6)*(A6/100))","v":0},0,{"$f":"G6*(C6/100)","v":0},0]
[{"$f":"VLOOKUP('Blend Calculator'!B12,'Feed cost & analysis'!1:1048576,5,FALSE)","v":85},{"$f":"VLOOKUP('Blend Calculator'!B12,'Feed cost & analysis'!1:1048576,6,FALSE)","v":13.3},{"$f":"VLOOKUP('Blend Calculator'!B12,'Feed cost & analysis'!1:1048576,7,FALSE)","v":30},{"$f":"VLOOKUP('Blend Calculator'!B12,'Feed cost & analysis'!1:1048576,10,FALSE)","v":40},{"$f":"'Blend Calculator'!D12","v":0},{"$f":"'Blend Calculator'!F12*'Blend Calculator'!D12","v":0},{"$f":"(1000*(E7)*(A7/100))","v":0},0,0,{"$f":"(G7/1000)*D7","v":0}]
[{"$f":"VLOOKUP('Blend Calculator'!B13,'Feed cost & analysis'!1:1048576,5,FALSE)","v":45},{"$f":"VLOOKUP('Blend Calculator'!B13,'Feed cost & analysis'!1:1048576,6,FALSE)","v":14.2},{"$f":"VLOOKUP('Blend Calculator'!B13,'Feed cost & analysis'!1:1048576,7,FALSE)","v":37},{"$f":"VLOOKUP('Blend Calculator'!B13,'Feed cost & analysis'!1:1048576,10,FALSE)","v":1.3},{"$f":"'Blend Calculator'!D13","v":0},{"$f":"'Blend Calculator'!F13*'Blend Calculator'!D13","v":0},{"$f":"(1000*(E8)*(A8/100))","v":0},{"$f":"(G8/1000)*B8","v":0},0,0]
[{"$f":"VLOOKUP('Blend Calculator'!B14,'Feed cost & analysis'!1:1048576,5,FALSE)","v":99.5},{"$f":"VLOOKUP('Blend Calculator'!B14,'Feed cost & analysis'!1:1048576,6,FALSE)","v":0},{"$f":"VLOOKUP('Blend Calculator'!B14,'Feed cost & analysis'!1:1048576,7,FALSE)","v":280},{"$f":"VLOOKUP('Blend Calculator'!B14,'Feed cost & analysis'!1:1048576,10,FALSE)","v":0},{"$f":"'Blend Calculator'!D14","v":0},{"$f":"'Blend Calculator'!F14*'Blend Calculator'!D14","v":0},0,0,0,0]
[{"$f":"VLOOKUP('Blend Calculator'!B15,'Feed cost & analysis'!1:1048576,5,FALSE)","v":86},{"$f":"VLOOKUP('Blend Calculator'!B15,'Feed cost & analysis'!1:1048576,6,FALSE)","v":1},{"$f":"VLOOKUP('Blend Calculator'!B15,'Feed cost & analysis'!1:1048576,7,FALSE)","v":1},{"$f":"VLOOKUP('Blend Calculator'!B15,'Feed cost & analysis'!1:1048576,10,FALSE)","v":0},{"$f":"'Blend Calculator'!D15","v":0},{"$f":"'Blend Calculator'!F15*'Blend Calculator'!D15","v":0},0,0,0,0]
[{"$f":"VLOOKUP('Blend Calculator'!B16,'Feed cost & analysis'!1:1048576,5,FALSE)","v":85},{"$f":"VLOOKUP('Blend Calculator'!B16,'Feed cost & analysis'!1:1048576,6,FALSE)","v":10},{"$f":"VLOOKUP('Blend Calculator'!B16,'Feed cost & analysis'!1:1048576,7,FALSE)","v":20},{"$f":"VLOOKUP('Blend Calculator'!B16,'Feed cost & analysis'!1:1048576,10,FALSE)","v":0},{"$f":"'Blend Calculator'!D16","v":0},{"$f":"'Blend Calculator'!F16*'Blend Calculator'!D16","v":0},{"$f":"(1000*(E11)*(A11/100))","v":0},{"$f":"(G11/1000)*B11","v":0},0,0]
[]
[{"$nulls":4},"FW",{"$f":"F14*G14","v":188.39619450317122},{"$f":"SUM(G2:G11)","v":866},{"$f":"SUM(H2:H11)","v":11.0806},{"$f":"SUM(I2:I11)","v":159.96199999999999},{"$f":"SUM(J2:J11)","v":35.634},"FW"]
[{"$nulls":4},"DM",{"$f":"SUM(F2:F11)","v":217.54756871035937},{"$f":"G13/1000","v":0.86599999999999999},{"$f":"H13/(G13/1000)","v":12.795150115473442},{"$f":"I13/(G13/1000)","v":184.71362586605079},{"$f":"J13/(G13/1000)","v":41.147806004618936},"DM"]